<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
 <head>
  <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  <title>SQL types with PDO_4D and PHP</title>

 </head>
 <body><div class="manualnavbar" style="text-align: center;">
 <div class="prev" style="text-align: left; float: left;"><a href="pdo-4d.constants.html">Constants for PDO_4D</a></div>
 <div class="next" style="text-align: right; float: right;"><a href="ref.pdo-4d.sql4d.html">SQL acceptable by 4D</a></div>
 <div class="up"><a href="ref.pdo-4d.html">4D (PDO)</a></div>
 <div class="home"><a href="index.html">PHP Manual</a></div>
</div><hr /><div id="pdo-4d.sqltypes" class="refentry">
 <div class="refnamediv">
  <h1 class="refname">SQL types with PDO_4D and PHP</h1>
  <p class="verinfo">(No version information available, might only be in Git)</p><p class="refpurpose"><span class="refname">SQL types with PDO_4D and PHP</span> &mdash; <span class="dc-title">SQL types with PDO_4D and PHP</span></p>

 </div>

 <div class="refsect1 description" id="refsect1-pdo-4d.sqltypes-description">
  <p class="para">
    <table class="doctable table">
     <caption><strong>Supported SQL types</strong></caption>
     
      <thead>
       <tr>
        <th>Type SQL 4D</th>
        <th>Equivalent 4D</th>
        <th>Note</th>
       </tr>

      </thead>

      <tbody class="tbody">
       <tr>
        <td>ALPHA_NUMERIC</td>
        <td>TEXT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>VARCHAR</td>
        <td>TEXT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>TEXT</td>
        <td>TEXT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>TIMESTAMP</td>
        <td>DATE</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>INTERVAL</td>
        <td>HOUR</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>DURATION</td>
        <td>HOUR</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>BOOLEAN</td>
        <td>BOOLEAN</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>BIT</td>
        <td>BOOLEAN</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>BYTE</td>
        <td>INT32</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>INT16</td>
        <td>SMALLINT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>SMALLINT</td>
        <td>SMALLINT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>INT32</td>
        <td>INT32</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>INT</td>
        <td>INT32</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>INT64</td>
        <td>INT64</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>NUMERIC</td>
        <td>INT64</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>REAL</td>
        <td>REAL</td>
        <td>Unsupported (use VARCHAR conversion)</td>
       </tr>

       <tr>
        <td>FLOAT</td>
        <td>FLOAT</td>
        <td>Unsupported (use VARCHAR conversion)</td>
       </tr>

       <tr>
        <td>DOUBLE PRECISION</td>
        <td>FLOAT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>BLOB</td>
        <td>BLOB</td>
        <td>Must use a prepared statement, and <strong><code>PDO::PARAM_LOB</code></strong></td>
       </tr>

       <tr>
        <td>BIT VARYING</td>
        <td>BLOB</td>
        <td>Must use a prepared statement, and <strong><code>PDO::PARAM_LOB</code></strong></td>
       </tr>

       <tr>
        <td>CLOB</td>
        <td>TEXT</td>
        <td class="empty">&nbsp;</td>
       </tr>

       <tr>
        <td>PICTURE</td>
        <td>PICTURE</td>
        <td>Must use a prepared statement, and <strong><code>PDO::PARAM_LOB</code></strong></td>
       </tr>

      </tbody>
     
    </table>

   </p>
  </div>

 </div><hr /><div class="manualnavbar" style="text-align: center;">
 <div class="prev" style="text-align: left; float: left;"><a href="pdo-4d.constants.html">Constants for PDO_4D</a></div>
 <div class="next" style="text-align: right; float: right;"><a href="ref.pdo-4d.sql4d.html">SQL acceptable by 4D</a></div>
 <div class="up"><a href="ref.pdo-4d.html">4D (PDO)</a></div>
 <div class="home"><a href="index.html">PHP Manual</a></div>
</div></body></html>
